EMT Practice Test

1. Question Content...

Previous Submit Next
Was this helpful? Upvote!
Question List

Question1: When exporting from SAP Analytics Cloud to SAP Business Warehouse, which of the following are active by default? Note: There are 2 correct answers to this question.

Question2: You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types can you use? Note: There are 2 correct answers to this question.

Question3: Which data locking status can you use to prevent manual data entry?

Question4: You have compared the data version options in stories vs. SAP Analysis, Edition for Microsoft Office. What did you discover?

Question5: You enter plan values by year and product group. You want to allocate these values to months and products in proportion to last year's actual data. What setting in the allocation process is required to achieve this?

Question6: Which work files can you access when you run a planning process? Note: There are 2 correct answers to this question.

Question7: Which account types allow you to display database values with the opposite sign in stories? Note: There are 2 correct answers to this question.

Question8: You have a planning model with the following dimensions; Account, Product, Profit Center, Date, and Version. In a story, which new master data can you add on the fly? Note: There are 2 correct answers to this question.

Question9: You create a dimension in SAP Analytics Cloud with a hierarchy. You want to update the new dimension with data from a characteristic in SAP Business Warehouse using SAP recommended practices. To populate the members and the hierarchy, what steps must you take? Note: There are 3 correct answers to this question

Question10: From which S/4HANA source table can you import actual data for cost centers?

Question11: What can you use to restrict input in a story based on nested conditions?

Question12: Which of the following actions on the date dimension are available in Value Driver Trees? Note: There are 2 correct answers to this question.

Question13: Which of the following can you use to create an SAP Analytics Cloud planning model? Note: There are 3 correct answers to thisquestion.

Question14: What master data can you update during the import of transaction data into an SAP Analytics Cloud planning model with private and public dimensions?

Question15: In the visual editor for advanced formulas, which of the following formula options can you select? Note: There are 2 correct answers to this question.

Question16: Which DataStore object (advanced) properties must be selected to export data to SAP Business Warehouse?
Note: There are 2 correct answers to this question.

Question17: In SAP Analytics Cloud: where can you apply data security ? Note: There are 2 correct answers to this question.

Question18: You have a New Model that only contains local currency values. When the New Model is used in stories, you need model-configured group currency values that are not stored in the database. What type of measure would you include in the New Model to meet the requirement?

Question19: What can you schedule from the SAP Analytics Cloud calendar? Note: There are 2 correct answers to this question.

Question20: You have financial data from SAP S/4HANA with local currency, group currency, and quantity values. You need to import the data into SAP Analytics Cloud. Following the SAP best practice guidelines, how would you design a New Model?

Question21: Which hierarchy types are supported in an SAP Analytics Cloud dimension?

Question22: When you delete a planning model, what dimension types are always deleted? Note: There are 2 correct answers to this question.

Question23: Your account dimension has an account for Profit that is calculated as [Revenue] - [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?

Question24: You imported a transaction data file into an empty model with the results as shown in Figure A.
Later, a member of the finance team wants you to import a new data file. In the new data file, you find the following differences: The value of the Labor account has increased to 1600. There is a new record for the Services account, with a value of 250. The record for the Travel account has been deleted. To achieve the result shown in Figure B, which option must you use to update the data?

Question25: You are using SAP BPC, version for SAP BW/4HANA Standard option. When you create a planning model based on an SAP BPC model, what can you do in SAP Analytics Cloud? Note: There are 2 correct answers to this question.

Question26: You want to rebuild an SAP Analytics Cloud classic planning model but the Rebuild Model button is inactive.
Why might this happen? Note: There are 2 correct answers to this question.

Question27: Which of the following are prerequisites to export transaction data to a Data Store object (advanced) in SAP Business Warehouse? Note: There are 2 correct answers to this question.

Question28: What does SAP recommend you do before you import data from SAP Business Warehouse to SAP Analytics Cloud?

Question29: You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does the auto-complete feature return? Note: There are 2 correct answers to this question.

Question30: Which of the following SAP Business Warehouse variable types can be used when importing data to SAP Analytics Cloud? Note: There are 2 correct answers to this question.

Question31: What node types can be imported from S/4HANA? Note: There are 3 correct answers to this question.